package anbook.dao;

import java.util.List;

import anbook.dto.Board_reply;

public interface IBoardReply {
	void insertBoardReply(Board_reply reply);
	void deleteBoardReply(int idx);
	List<Board_reply> getBoardReplys(int idx);
	void updateBoardReply(Board_reply reply);
	void allDeleteBoardReply(int idx);
	
	public static final String SQL_INSERT_BOARDREPLY = "insert into board_reply(b_num, mb_email, re_context, re_wdate, re_ref, re_step) values(?,?,?,now(),?,?)";
	public static final String SQL_DELETE_BOARDREPLY = "delete from board_reply where re_num = ?";
	public static final String SQL_GET_BOARDREPLYS = "select * from board_reply where b_num = ? order by re_ref, re_step";
	public static final String SQL_UPDATE_BOARDREPLY = "update board_reply set re_context = ?, re_wdate=now() where re_num = ?";
	public static final String SQL_ALLDELETE_BOARDREPLY = "delete from board_reply where b_num=?";
}
